package cn.ticket.dao;

import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import cn.ticket.model.Workticketorder;

public interface WorkticketorderMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Workticketorder record);

    int insertSelective(Workticketorder record);

    Workticketorder selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Workticketorder record);

    int updateByPrimaryKey(Workticketorder record);
    
    List<Map<String, Object>> getAuditingTicketInfo();
    
    List<Map<String, Object>> getAuditingTicketInfoByDepartmentId(@Param("departmentId") Integer departmentId);
    
    List<Map<String, Object>> getInfoByDepartureDate(@Param("departureDate") Date departureDate);
    
    List<Map<String, Object>> getInfoByDepartureDateRange(@Param("startDate") Date startDate,@Param("endDate") Date endDate);
    
    List<Map<String, Object>> getAuditedTicketInfoByStaffId(@Param("auditStaffId") Integer auditStaffId);
    
    List<Map<String, Object>> getValidateTicketInfoByStaffId(@Param("staffId") Integer staffId);
    
    List<Map<String, Object>> getInvalidateTicketInfoByStaffId(@Param("staffId") Integer staffId);
    
    List<Map<String, Object>> getAuditedTicketInfoByAuditorId(@Param("auditorId") Integer auditorId);
    
    List<Map<String, Object>> getInfoByBusId(@Param("busId")Integer busId);
}